In [2]:
import pandas as pd
import numpy as np
import folium
import seaborn
import matplotlib.pyplot as plt
import os
In [3]:
df=pd.read_csv("C:\\Users\\neeli\\Downloads\\Dataset .csv")
df.head()
Out[3]:
| Restaurant ID | Restaurant Name | Country Code | City | Address | Locality | Locality Verbose | Longitude | Latitude | Cuisines | ... | Currency | Has Table booking | Has Online delivery | Is delivering now | Switch to order menu | Price range | Aggregate rating | Rating color | Rating text | Votes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 6317637 | Le Petit Souffle | 162 | Makati City | Third Floor, Century City Mall, Kalayaan Avenu... | Century City Mall, Poblacion, Makati City | Century City Mall, Poblacion, Makati City, Mak... | 121.027535 | 14.565443 | French, Japanese, Desserts | ... | Botswana Pula(P) | Yes | No | No | No | 3 | 4.8 | Dark Green | Excellent | 314 |
| 1 | 6304287 | Izakaya Kikufuji | 162 | Makati City | Little Tokyo, 2277 Chino Roces Avenue, Legaspi... | Little Tokyo, Legaspi Village, Makati City | Little Tokyo, Legaspi Village, Makati City, Ma... | 121.014101 | 14.553708 | Japanese | ... | Botswana Pula(P) | Yes | No | No | No | 3 | 4.5 | Dark Green | Excellent | 591 |
| 2 | 6300002 | Heat - Edsa Shangri-La | 162 | Mandaluyong City | Edsa Shangri-La, 1 Garden Way, Ortigas, Mandal... | Edsa Shangri-La, Ortigas, Mandaluyong City | Edsa Shangri-La, Ortigas, Mandaluyong City, Ma... | 121.056831 | 14.581404 | Seafood, Asian, Filipino, Indian | ... | Botswana Pula(P) | Yes | No | No | No | 4 | 4.4 | Green | Very Good | 270 |
| 3 | 6318506 | Ooma | 162 | Mandaluyong City | Third Floor, Mega Fashion Hall, SM Megamall, O... | SM Megamall, Ortigas, Mandaluyong City | SM Megamall, Ortigas, Mandaluyong City, Mandal... | 121.056475 | 14.585318 | Japanese, Sushi | ... | Botswana Pula(P) | No | No | No | No | 4 | 4.9 | Dark Green | Excellent | 365 |
| 4 | 6314302 | Sambo Kojin | 162 | Mandaluyong City | Third Floor, Mega Atrium, SM Megamall, Ortigas... | SM Megamall, Ortigas, Mandaluyong City | SM Megamall, Ortigas, Mandaluyong City, Mandal... | 121.057508 | 14.584450 | Japanese, Korean | ... | Botswana Pula(P) | Yes | No | No | No | 4 | 4.8 | Dark Green | Excellent | 229 |
5 rows × 21 columns
In [4]:
df.columns
Out[4]:
Index(['Restaurant ID', 'Restaurant Name', 'Country Code', 'City', 'Address',
'Locality', 'Locality Verbose', 'Longitude', 'Latitude', 'Cuisines',
'Average Cost for two', 'Currency', 'Has Table booking',
'Has Online delivery', 'Is delivering now', 'Switch to order menu',
'Price range', 'Aggregate rating', 'Rating color', 'Rating text',
'Votes'],
dtype='object')
In [5]:
#level-2
#task-1
#ratings resturants
#Analyze the distribution of aggregate ratings and determine the most common rating range
In [6]:
ratings_column = df['Aggregate rating']
plt.figure(figsize=(8, 6))
plt.hist(ratings_column, bins=20, color='skyblue', edgecolor='black')
plt.xlabel('Aggregate Rating')
plt.ylabel('Frequency')
plt.title('Distribution of Aggregate Ratings')
plt.grid(axis='y')
plt.show()
most_common_bin = ratings_column.mode().values[0]
print(f"Most common rating range: {most_common_bin:.2f}")
Most common rating range: 0.00
In [7]:
#Calculate the average number of votes received by restaurants.
In [8]:
votes_column = df['Votes']
average_votes = votes_column.mean()
print(f"Average number of votes received by restaurants: {average_votes:.2f}")
Average number of votes received by restaurants: 156.91
In [9]:
#level-2
#task-2
#Cusinies combinations
#Identify the most common combinations of cuisines in the dataset.
In [10]:
cuisines_column = df['Cuisines']
cuisines_column = cuisines_column.astype(str)
all_cuisines = [cuisine.strip() for cuisines in cuisines_column for cuisine in cuisines.split(',') if isinstance(cuisines, str)]
cuisine_series = pd.Series(all_cuisines)
cuisine_counts = cuisine_series.value_counts()
print("Top 10 most common cuisine combinations:")
print(cuisine_counts.nlargest(10))
Top 10 most common cuisine combinations: North Indian 3960 Chinese 2735 Fast Food 1986 Mughlai 995 Italian 764 Bakery 745 Continental 736 Cafe 703 Desserts 653 South Indian 636 Name: count, dtype: int64
In [11]:
#level-2
#task-3
#Geographic Analysis
#Plot the locations of restaurants on a map using longitude and latitude coordinates.columns = df.columns.str.strip().str.lower()
In [18]:
df.columns = df.columns.str.strip().str.lower()
df = df.dropna(subset=['latitude', 'longitude'])
center_lat = df['latitude'].mean()
center_long = df['longitude'].mean()
restaurant_map = folium.Map(location=[center_lat, center_long], zoom_start=12)
for idx, row in df.iterrows():
folium.Marker(
location=[row['latitude'], row['longitude']],
popup=row['restaurant name'],
tooltip=row['restaurant name']
).add_to(restaurant_map)
restaurant_map.save('restaurant_map.html')
restaurant_map
Out[18]:
Make this Notebook Trusted to load map: File -> Trust Notebook
In [130]:
#Identify any patterns or clusters of restaurants in specific areas.
In [13]:
chain_counts = df["Restaurant Name"].value_counts()
restaurant_chains = chain_counts[chain_counts > 1]
print("Restaurant Chains:")
for chain_name, count in restaurant_chains.items():
print(f"{chain_name}: {count} locations")
Restaurant Chains: Cafe Coffee Day: 83 locations Domino's Pizza: 79 locations Subway: 63 locations Green Chick Chop: 51 locations McDonald's: 48 locations Keventers: 34 locations Pizza Hut: 30 locations Giani: 29 locations Baskin Robbins: 28 locations Barbeque Nation: 26 locations Giani's: 22 locations Barista: 22 locations Dunkin' Donuts: 22 locations Costa Coffee: 20 locations Pind Balluchi: 20 locations Wah Ji Wah: 19 locations Twenty Four Seven: 19 locations Pizza Hut Delivery: 19 locations Sagar Ratna: 19 locations Republic of Chicken: 18 locations KFC: 18 locations Starbucks: 18 locations Chaayos: 18 locations Burger King: 16 locations Haldiram's: 16 locations Shree Rathnam: 15 locations Frontier: 14 locations Moti Mahal Delux: 14 locations Bikanervala: 14 locations Aggarwal Sweets: 14 locations Behrouz Biryani: 13 locations Karim's: 13 locations Bikaner Sweets: 13 locations Chicago Pizza: 12 locations Apni Rasoi: 12 locations 34, Chowringhee Lane: 12 locations Wow! Momo: 11 locations Madras Cafe: 11 locations Burger Point: 11 locations Gopala: 10 locations Shama Chicken Corner: 9 locations Berco's: 9 locations Nirula's Ice Cream: 9 locations Sardar A Pure Meat Shop: 9 locations Yo! China: 9 locations Cocoberry: 9 locations Punjabi Tadka: 8 locations Angels in my Kitchen: 8 locations Faasos: 8 locations Ovenstory Pizza: 8 locations Chowringhee: 8 locations Punjabi Chaap Corner: 8 locations Kebab Xpress: 8 locations Nazeer Foods: 7 locations RollsKing: 7 locations Tpot: 7 locations Mocha: 7 locations Dolce Gelato: 7 locations Tibb's Frankie: 7 locations The Yellow Chilli: 7 locations Slice of Italy: 7 locations BTW: 7 locations Khan Chacha: 7 locations Chawla's?_: 7 locations China Town: 7 locations Chinese Hut: 7 locations Sanjha Chulha: 6 locations Moti Mahal Delux Tandoori Trail: 6 locations Mr. Sub: 6 locations Al Bake: 6 locations Bikaner Sweets & Restaurant: 6 locations TGI Friday's: 6 locations Kings Kulfi: 6 locations Pudding & Pie: 6 locations Cafe Coffee Day - The Lounge: 6 locations Southy: 6 locations The Diet Kitchen: 6 locations Biryani Blues: 6 locations Goli Vada Pav No. 1: 6 locations Punjabi Rasoi: 6 locations The Beer Cafe: 6 locations Wrapss: 6 locations Mainland China: 6 locations Farzi Cafe: 6 locations Red Chilli: 5 locations Nathu's Sweets: 5 locations Instapizza: 5 locations Chili's: 5 locations Nando's: 5 locations Aggarwal Sweet India: 5 locations Texas Roadhouse: 5 locations Cake Point: 5 locations Pita Pit: 5 locations Chinese Corner: 5 locations The Midnight Heroes: 5 locations Kake Da Hotel: 5 locations L'Opera: 5 locations Nukkadwala: 5 locations Flirty Momo's: 5 locations Viva Hyderabad: 5 locations Swagath: 5 locations Sandoz: 5 locations Punjab Grill: 5 locations Kettle & Kegs: 5 locations The Chinese Hut: 5 locations Captain Grub: 5 locations Mad Over Donuts: 5 locations Aggarwal Sweet Corner: 5 locations SGF - Spice Grill Flame: 5 locations Shree Bikaner Misthan Bhandar: 5 locations Da Pizza Corner: 5 locations Happy Hakka: 5 locations Hot Pot: 4 locations Chai Garam: 4 locations Gola Sizzlers: 4 locations Pakwan: 4 locations Applebee's: 4 locations Kathi Junction: 4 locations Qureshi's Kabab Corner: 4 locations Meatwale.com: 4 locations Jamie's Italian: 4 locations GoGourmet: 4 locations The Coffee Bean & Tea Leaf: 4 locations Sugar & Spice - Le Marche: 4 locations The Kathis: 4 locations Public Cafe: 4 locations Kwality Wall's Swirl's: 4 locations Chaska: 4 locations Bun Intended: 4 locations Pirates of Grill: 4 locations South Indian Hut: 4 locations DCK- Dana Choga's Kitchen: 4 locations Gelato Vinto: 4 locations Jungle Jamboree: 4 locations Bawarchi: 4 locations Deez Biryani & Kebabs: 4 locations Chai Point: 4 locations Hong Kong Express: 4 locations Nirula's: 4 locations Aapki Rasoi: 4 locations Burger Xpress: 4 locations Rainbows: 4 locations Mx Corn: 4 locations Colonel's Kababz: 4 locations Punjabi Zaika: 4 locations FreshMenu: 4 locations Chawla's 2: 4 locations Open Oven: 4 locations Tea Villa Cafe: 4 locations Puri Bakers: 4 locations Nizam's Kathi Kabab: 4 locations Zaika: 4 locations AB's - Absolute Barbecues: 4 locations Nite Bites: 4 locations Punjabi's Veg Grill: 4 locations Momo-Cha: 4 locations Super Cake Shop: 4 locations Big Chill: 4 locations Movenpick: 3 locations Mamagoto: 3 locations Kanwarji's: 3 locations Big Yellow Door: 3 locations Foodies: 3 locations Doughlicious: 3 locations Zizo: 3 locations Onesta: 3 locations Chimney: 3 locations Aggarwal Bikaner Sweets: 3 locations Zaffran: 3 locations Foodhall: 3 locations Just Vada Pav: 3 locations Roll Club: 3 locations Amici Cafe: 3 locations Chinese Food Corner: 3 locations Kerala Cafe: 3 locations Wok On Fire: 3 locations Bats On Delivery: 3 locations Amul Ice-Cream Parlour: 3 locations Cafe Delhi Heights: 3 locations Bharat Sweets: 3 locations Chawla's Chic Inn: 3 locations Tikka Town: 3 locations Talaga Sampireun: 3 locations Bikkgane Biryani: 3 locations Shawarma Wala: 3 locations True Blue: 3 locations Punjabi Dhaba: 3 locations Food Plaza: 3 locations Chinese Food: 3 locations SodaBottleOpenerWala: 3 locations Breaktym: 3 locations Defence Bakery: 3 locations Muradabadi Shahi Biryani & Chicken Corner: 3 locations Tikka Junction: 3 locations Aggarwal Sweets India: 3 locations Not Just Paranthas: 3 locations Krispy Kreme: 3 locations HuHot Mongolian Grill: 3 locations Hard Rock Cafe: 3 locations Goosebumps: 3 locations Street Foods by Punjab Grill: 3 locations Habibi Express: 3 locations Joost Juice Bar: 3 locations Desi Vibes: 3 locations La Pino'z Pizza: 3 locations The Chai Story: 3 locations Wah G Wah: 3 locations Hira Sweets: 3 locations Hasty Tasty: 3 locations Shahenshah: 3 locations Midnight Hunger Hub: 3 locations Riyaz Biryani Corner: 3 locations Polka Pastry & Snack Bar: 3 locations Changezi Chicken: 3 locations Aggarwal Sweet Centre: 3 locations Urban Punjab: 3 locations Side Wok: 3 locations Havmor Ice Cream: 3 locations The Fisherman's Wharf: 3 locations Cafe Turtle: 3 locations Chaophraya: 3 locations Sri Balaji: 3 locations Chawla's Tandoori Junction: 3 locations Palmshore: 3 locations Rollmaal: 3 locations Speedy Chow: 3 locations Om Sweets & Snacks: 3 locations Taco Bell: 3 locations Food Scouts: 3 locations New Madras Cafe: 3 locations Cakes & Bakes: 3 locations Sushiya Express: 3 locations KB's Kulfi & Icecream: 3 locations Bunty Dhaba: 3 locations Flying Cakes: 3 locations Baked Buns: 3 locations Mitra Da Dhaba: 3 locations Mr. Brown: 3 locations Veg Ex: 3 locations BarShala: 3 locations Tea Halt: 3 locations 221 B Baker Street: 3 locations The Golden Dragon: 3 locations Burger Singh: 3 locations Finger Licious: 3 locations Pizza Hub: 3 locations The Chaiwalas: 3 locations Jaiveer Naan & Chaap: 3 locations Punjab Restaurant: 3 locations Captain Bill$ Deliverz: 3 locations Health Buzzz: 3 locations Little Chef: 3 locations Punjabi Pakwaan: 3 locations Biryani By Kilo: 3 locations QD's Restaurant: 3 locations Hangchuaa's Chinese Food Corner: 3 locations Indian Coffee House: 3 locations Dilli Darbar: 3 locations Niti Shake & Ice Cream Hub: 3 locations Saravana Bhavan: 3 locations Bake N Shake: 3 locations Gazebo: 3 locations Pizza Station: 3 locations D?_ner Grill: 3 locations Naivedyam: 3 locations Radha Swami Shudh Vaishno Dhaba: 3 locations Druk: 2 locations Qureshi Kabab Corner: 2 locations Da Pizza Zone: 2 locations The Cheesecake Factory: 2 locations Raj Restaurant: 2 locations The Night Owl: 2 locations Bikaner's: 2 locations Papa Veg Chinese Food: 2 locations Khan Chicken Biryani: 2 locations Bikaner Sweets & Bakers: 2 locations Metro Dhaba: 2 locations Naturals Ice Cream: 2 locations Zaika Kathi Rolls: 2 locations Flavours: 2 locations Spanish Delights: 2 locations Hunger's Hub: 2 locations Relax Xpress: 2 locations The Barbeque Company: 2 locations Dosa Plaza: 2 locations Whipped: 2 locations Night Munchers: 2 locations Khalsa Veg Corner: 2 locations Mr. Momo: 2 locations Hot Cherries: 2 locations Wild Chef House: 2 locations MR.D - Deliciousness Delivered: 2 locations Royal Spice: 2 locations The Great Kabab Factory: 2 locations Ceviche Tapas Bar & Restaurant: 2 locations Fresh Meat CO: 2 locations Brown Town: 2 locations Moksha: 2 locations Big Biryani: 2 locations Bon Bon Pastry Shop: 2 locations Mother's Kitchen: 2 locations Golden Bakery: 2 locations Mom's Kitchen: 2 locations New Punjabi Khana: 2 locations Oh Buoy: 2 locations Americana Kitchen and Bar: 2 locations Carl's Jr.: 2 locations Hungry - I: 2 locations Al Zaika: 2 locations SpiceKlub: 2 locations Delhi Club House: 2 locations Pebble Street: 2 locations Biryani Express: 2 locations Kati Roll Cottage: 2 locations Stop My Starvation: 2 locations Midnight Hunger: 2 locations Kulcha King: 2 locations Beijing Street: 2 locations Nazeer Delicacies: 2 locations Singz: 2 locations Pho King Awesome: 2 locations Anupam Sweets: 2 locations Baba Chicken Ludhiana Wale: 2 locations AB's Absolute Barbecues: 2 locations Rolling Beans: 2 locations The Culinary Pitaara: 2 locations Garam Dharam: 2 locations Chinese Fast Food: 2 locations The China Town: 2 locations Aggarwal Sweets Centre: 2 locations Embassy: 2 locations New Kadimi: 2 locations Caffe Tonino: 2 locations Pandit Ji Ki Apni Rasoi: 2 locations Shree Durga Dosa: 2 locations Sagar Dhaba: 2 locations Angeethi: 2 locations Basil Tree: 2 locations China Hot Pot: 2 locations Punjabee's Darbar: 2 locations Khana Khazana: 2 locations Natural Ice Cream: 2 locations Jyoti Sweets: 2 locations New Town Cafe - Park Plaza: 2 locations Biryani Vice: 2 locations Riyaz Chicken Corner: 2 locations Oberoi's: 2 locations Jahangeer Foods: 2 locations Green Restaurant: 2 locations Momos House: 2 locations Miam: 2 locations Delight Express: 2 locations China Hut: 2 locations Hawkers: 2 locations Crazy Noodles: 2 locations South Cafe: 2 locations Zaaika Junction: 2 locations Le Chef: 2 locations WTF - World's Tastiest Food: 2 locations Biryani Art: 2 locations Moon Bite: 2 locations Gupta Chat Corner: 2 locations Pizza King: 2 locations Pastry Palace: 2 locations Tipu Sultan: 2 locations All About Food: 2 locations Snack Shack: 2 locations Cafe Brown Sugar: 2 locations The Pirates Of China Town: 2 locations Arabian Delites: 2 locations Kake Di Hatti: 2 locations Burgrill: 2 locations Chilli Tadka: 2 locations Ashoka Restaurant: 2 locations Cafe Coffee Day The Square: 2 locations Delhi Chaat Bhandar: 2 locations Ashok Meat Wala: 2 locations Juice Lounge: 2 locations Shamji Sweets: 2 locations Fluffles - The Fluffy Waffle Co.: 2 locations Ram Chinese Food: 2 locations Chawnsan Chef: 2 locations Reena Restaurant: 2 locations Invitation: 2 locations Soya Bite's: 2 locations Choco Kraft: 2 locations Bakingo: 2 locations Gulab: 2 locations Garam Masala: 2 locations Anand Sweets: 2 locations Singh Chicken: 2 locations Baker's Stop: 2 locations Raj Rasoi: 2 locations Grover Sweets: 2 locations Dev Food: 2 locations Konetto Pizza: 2 locations Dunkin Donuts: 2 locations Perfect Bake: 2 locations Blue Tokai Coffee Roasters: 2 locations 34 Parkstreet Lane: 2 locations Pandey Chinese Hut: 2 locations Rajdhani Restaurant: 2 locations Maggi Point: 2 locations The Taste: 2 locations Flavours Kitchen: 2 locations Suruchi: 2 locations The Chocolate Room: 2 locations Aap Ki Khatir: 2 locations Roti Aur Boti: 2 locations Imperfecto: 2 locations Firangi Bake: 2 locations Out Of The Box: 2 locations Hungry Minister: 2 locations Biryani Bot: 2 locations Black Pepper: 2 locations Hurry's Paratha: 2 locations Yomo-Your Only Momo Outlet: 2 locations Jain Restaurant: 2 locations Dilli Light: 2 locations Burger Joint: 2 locations Hot Stuff: 2 locations Paradise: 2 locations Dilli BC: 2 locations Sumo Sushi: 2 locations Bakers Oven: 2 locations Punjabi By Nature: 2 locations Mogambo Kitchen: 2 locations Sbarro: 2 locations Paramjeet Machi Wala: 2 locations Kake Da Dhaba: 2 locations La Americana: 2 locations Mithaas: 2 locations Biryaniwala: 2 locations Kesarwa Bakez: 2 locations Nutritious Nation: 2 locations Bake Walkers: 2 locations Green Valley Chinese Food: 2 locations Chinese Hot: 2 locations Mithaas Sweets: 2 locations The Cake Shop: 2 locations China Garden: 2 locations Kumar Pastry Shop: 2 locations Twisted Tacos: 2 locations Hwealthcafe: 2 locations Whatslife.in: 2 locations Chutneez Restaurant Lounge & Bar: 2 locations Kamal's: 2 locations Shake Square: 2 locations Pasta Hub: 2 locations Chawla's Tandoori Xpress: 2 locations Caffe 9: 2 locations The Roll Van: 2 locations Truffles: 2 locations Lasha Chinese Food: 2 locations Baker Street: 2 locations Hot & Spicy: 2 locations Koyla Kebab: 2 locations Adyar Ananda Bhavan: 2 locations 10 Downing Street: 2 locations Matchbox: 2 locations Tamura: 2 locations Smoke House Deli: 2 locations Fit Bites: 2 locations Manohar Dairy And Restaurant: 2 locations Bombay Brasserie: 2 locations Flavors Of London: 2 locations Frozen Factory: 2 locations Bhappe Di Hatti: 2 locations Desi Tadka: 2 locations Kanha Sweets: 2 locations Teddy Boy: 2 locations KC Bakers: 2 locations Nawabi Mughlai Zaika: 2 locations The Flying Saucer Cafe: 2 locations Mysore Cafe: 2 locations The Tandoor: 2 locations The Junkyard Cafe: 2 locations Bikaner Misthan Bhandar: 2 locations Gupta Ji Ka Dhaba: 2 locations Gung The Palace: 2 locations Bhoj Restaurant: 2 locations The Kitchen: 2 locations Dezertfox: 2 locations 4700BC Popcorn: 2 locations Underdoggs Sports Bar & Grill: 2 locations San Carlo: 2 locations Bikano Chat Cafe: 2 locations Bengal Sweet Corner: 2 locations Amritsari Dhaba: 2 locations Metro Fast Food: 2 locations Shawarma King's: 2 locations Nagpal's: 2 locations Pizza Day: 2 locations Shankar Fast Food: 2 locations Chinese King: 2 locations Chao Cart: 2 locations The Mirch Masala: 2 locations Anjlika Pastry Shop: 2 locations Wai Yu Mun Ching: 2 locations Chili's Grill & Bar: 2 locations 6 Pack Momos: 2 locations Spooky Sky: 2 locations Night Food Xprs: 2 locations BonJuz: 2 locations Weird Time Food: 2 locations Twigly: 2 locations The Artful Baker: 2 locations Amar Bakery: 2 locations Perch Wine & Coffee Bar: 2 locations Liquid: 2 locations Dishoom: 2 locations Granite City Food & Brewery: 2 locations Taste of India: 2 locations Magic Masala: 2 locations Gymkhana: 2 locations High On Burgers: 2 locations Harry's Bar + Cafe: 2 locations The Blue Tandoor: 2 locations Eggers Madhouse: 2 locations D Food: 2 locations Asian Haus: 2 locations Sonya Bakery Cafe: 2 locations Bikaner Kesarvala: 2 locations Sibang Bakery: 2 locations Bhimsain's Bengali Sweet House: 2 locations Made In Punjab: 2 locations Bijoli Grill: 2 locations Chai Thela: 2 locations Balaji Dhaba: 2 locations Aggarwal Sweets & Restaurant: 2 locations Wendy's: 2 locations Madras Dosa & Chinese: 2 locations Sethi's The Cake Shop: 2 locations Mitthu Tikki Wala: 2 locations Paapi Paet: 2 locations Manohar Bikkaneri: 2 locations Smaaash: 2 locations A Piece of Paris: 2 locations Cones & Curries: 2 locations Urban Dhaba: 2 locations Mahi Rasoi: 2 locations Munch Nation: 2 locations Sadda Adda: 2 locations The Chatter House: 2 locations Crudo Juicery: 2 locations VadaPav 'n' Frankie: 2 locations The Breakfast Club: 2 locations Oberoi Biryani: 2 locations Wheelyz: 2 locations Yadav Sweets: 2 locations Los Agaves: 2 locations Drool Waffles: 2 locations Hornbill: 2 locations The Cafe: 2 locations Wagh Bakri Tea Lounge: 2 locations Chalte Firte Momos & Special Foods: 2 locations Ammu's South Indian Restaurant: 2 locations Nooba: 2 locations Fish Streat: 2 locations The Big Chill Cakery: 2 locations Pizza Diet: 2 locations Madras Coffee House: 2 locations Garota de Ipanema: 2 locations Barbeque Ville: 2 locations Little Italy: 2 locations Kebab Gali: 2 locations Murliwala Bakers: 2 locations Litti.In: 2 locations Baking Bad: 2 locations Tandoori Junction: 2 locations First Eat: 2 locations Cafe Buddy's: 2 locations Coldpress Company: 2 locations Say Cheese: 2 locations ZASTY: 2 locations Pizza Yum: 2 locations JSB Evergreen Snack & Sweets: 2 locations Fast Trax: 2 locations Clever Fox Cafe: 2 locations Joey's Pizza: 2 locations Grillz: 2 locations Coco Bambu: 2 locations Timboo Cafe: 2 locations Nanking: 2 locations Habibi: 2 locations Din Tai Fung: 2 locations Cinnabon: 2 locations Silantro Fil-Mex: 2 locations EDC Mania: 2 locations Drifters Cafe: 2 locations Haldiram Bhujiawala: 2 locations D?_vero??lu: 2 locations The Mad Teapot/The Wishing Chair: 2 locations Spice Route: 2 locations The Bake Studio: 2 locations Puja Sandwich House: 2 locations OCD - Online Cake Delivery: 2 locations Muffins: 2 locations Rasoi - The Indian Zaika: 2 locations Vadapav Junction: 2 locations Super Snacks: 2 locations Green Chilli: 2 locations Roll Corner: 2 locations Bobby Tikki Wala: 2 locations Dabba Meat: 2 locations Crust N Cakes: 2 locations Chennai Express: 2 locations Fresh n Refresh: 2 locations Garden Hut: 2 locations Mellow Mushroom: 2 locations Rhinehart's Oyster Bar: 2 locations Cake 24x7: 2 locations Bake Club: 2 locations Royale Bakers: 2 locations South Indian Corner: 2 locations Fabulous Cake Bites: 2 locations Chaap Point: 2 locations The National: 2 locations Syall Kotian Da Dhaba: 2 locations Rajshree: 2 locations Go Kylin: 2 locations Aggarwal's Sweets Paradise: 2 locations Burger Hut: 2 locations Lazeez Restaurant: 2 locations Madhuvan Chinese Fast Food: 2 locations Chick-fil-A: 2 locations Cook Du Kdu: 2 locations Theos: 2 locations Ghar Ka Khana: 2 locations Food Express: 2 locations Mirchievous: 2 locations Rasoi: 2 locations Bikaner Rasoi: 2 locations Alaturka: 2 locations Kitchen King: 2 locations Big Fat Sandwich: 2 locations Red Mango: 2 locations Food Factory: 2 locations Hunger Strike: 2 locations Kamboj's: 2 locations Tandoori Tadka: 2 locations Cake Palace: 2 locations Hot Joint Fast Food: 2 locations Hyderabad House: 2 locations Ichiban: 2 locations Aggarwal Bikaneri Sweets: 2 locations Papa Buns: 2 locations Adarsh Kulfi: 2 locations Punjabi Chicken: 2 locations Evergreen Sweets: 2 locations bu??no: 2 locations Ankur Family Restaurant: 2 locations Effingut Brewerkz: 2 locations Comesum: 2 locations Aggarwal Sweet & Bakers: 2 locations Brijwasi Restaurant: 2 locations Street Cafe: 2 locations Shyam Sweets: 2 locations Chawla Family Restaurant: 2 locations Country Curries: 2 locations Faaso's: 2 locations Green Leaf: 2 locations The Crab Shack: 2 locations Vaishno Punjabi Dhaba: 2 locations Vaishno Rasoi: 2 locations Dilli Rasoi: 2 locations Cafe Diva: 2 locations Ramesh Vaishno Dhaba: 2 locations Yumm Biryani: 2 locations Essen Foods: 2 locations Chai Mantra: 2 locations Pasta Hut: 2 locations Senorita's: 2 locations Caff?? La Poya: 2 locations South Indian Cafe: 2 locations Chawlas 2: 2 locations Tea Trails: 2 locations Laxmi Ice Cream: 2 locations Organic Express: 2 locations Yo! Dimsum: 2 locations Jack Po!tato's: 2 locations The Chef: 2 locations Patiala Shahi: 2 locations Sandwich King: 2 locations Special Chicken Biryani: 2 locations The Belgian Fries Company: 2 locations Wood Box Cafe: 2 locations Shalimar Vyanjan: 2 locations Arabian Nites: 2 locations Moti Mahal Delux- Legendary Culinary: 2 locations The Square Meal: 2 locations Night Food Delivery: 2 locations Mr. Baker's: 2 locations Aureo Dine & Bake House: 2 locations Kaveri Restaurant And Caterers: 2 locations U Like: 2 locations New Zaika: 2 locations Big Wong XL: 2 locations Gullu's: 2 locations Kolkata Kathi Roll: 2 locations Italiano: 2 locations Kolkata Hot Kathi Roll: 2 locations Zooby's Kitchen: 2 locations Hotel Malabar: 2 locations Dana Pani: 2 locations Big Dragon: 2 locations Standard Sweets: 2 locations Kolkata Biryani House: 2 locations Circus: 2 locations Pitstop: 2 locations The Big Scoop: 2 locations Imly: 2 locations Prince Chaat Corner: 2 locations Chawla's: 2 locations Khidmat: 2 locations The Creamery: 2 locations Shri Ram Restaurant: 2 locations Chauhan Hotel: 2 locations Au Bon Pain: 2 locations Let's Noodle: 2 locations Fat Lulu's: 2 locations Oh! Calcutta: 2 locations Otik Cake Shop: 2 locations Olive Bistro: 2 locations Raasta: 2 locations The Pint Room: 2 locations Snacks Point: 2 locations The Dosa King: 2 locations Chokola: 2 locations Town Hall: 2 locations Halki Aanch: 2 locations Snack Junction: 2 locations Delhi Biryani Hut: 2 locations Beliram Degchiwala: 2 locations
In [132]:
#level-2
#task-4
#resturant chains
#Identify if there are any restaurant chains present in the dataset
In [133]:
restaurant_counts = df['Restaurant Name'].value_counts()
chains = restaurant_counts[restaurant_counts > 1]
print(f"Number of potential restaurant chains: {len(chains)}")
print(chains)
Number of potential restaurant chains: 734
Restaurant Name
Cafe Coffee Day 83
Domino's Pizza 79
Subway 63
Green Chick Chop 51
McDonald's 48
..
Town Hall 2
Halki Aanch 2
Snack Junction 2
Delhi Biryani Hut 2
Beliram Degchiwala 2
Name: count, Length: 734, dtype: int64
In [134]:
#Analyze the ratings and popularity of different restaurant chains
In [135]:
chain_analysis = df.groupby('Restaurant Name').agg(
Average_Rating=('Aggregate rating', 'mean'),
Total_Votes=('Votes', 'sum'),
Location_Count=('Restaurant ID', 'count')
).reset_index()
chain_analysis = chain_analysis[chain_analysis['Location_Count'] > 1]
top_chains_by_rating = chain_analysis.sort_values(by='Average_Rating', ascending=False)
top_chains_by_popularity = chain_analysis.sort_values(by='Total_Votes', ascending=False)
print("Top Restaurant Chains by Average Rating:")
print(top_chains_by_rating.head(10))
print("\nTop Restaurant Chains by Total Votes:")
print(top_chains_by_popularity.head(10))
Top Restaurant Chains by Average Rating:
Restaurant Name Average_Rating Total_Votes Location_Count
6263 Talaga Sampireun 4.900 5514 3
5850 Silantro Fil-Mex 4.850 1364 2
102 AB's Absolute Barbecues 4.850 3151 2
101 AB's - Absolute Barbecues 4.825 13400 4
4464 Naturals Ice Cream 4.800 3094 2
2806 Gymkhana 4.700 328 2
6504 The Cheesecake Factory 4.650 3010 2
2076 Dishoom 4.600 1269 2
2585 Garota de Ipanema 4.600 59 2
1510 Chili's 4.580 8156 5
Top Restaurant Chains by Total Votes:
Restaurant Name Average_Rating Total_Votes Location_Count
663 Barbeque Nation 4.353846 28142 26
101 AB's - Absolute Barbecues 4.825000 13400 4
785 Big Chill 4.475000 10853 4
2297 Farzi Cafe 4.366667 10098 6
6988 Truffles 3.950000 9682 2
1510 Chili's 4.580000 8156 5
3261 Joey's Pizza 4.250000 7807 2
796 Big Yellow Door 4.266667 7511 3
5571 Saravana Bhavan 4.133333 7238 3
6080 Starbucks 3.805556 7139 18
In [ ]:
#level-3
#task-1
#Task: Restaurant Reviews
#Identify if there are any restaurant chains present in the dataset
In [15]:
import pandas as pd
restaurant_counts =df['Restaurant Name'].value_counts()
restaurant_chains = restaurant_counts[restaurant_counts > 1]
print("Restaurant Chains:")
print(restaurant_chains)
Restaurant Chains:
Restaurant Name
Cafe Coffee Day 83
Domino's Pizza 79
Subway 63
Green Chick Chop 51
McDonald's 48
..
Town Hall 2
Halki Aanch 2
Snack Junction 2
Delhi Biryani Hut 2
Beliram Degchiwala 2
Name: count, Length: 734, dtype: int64
In [ ]:
#Analyze the ratings and popularity of different restaurant chains
In [17]:
import pandas as pd
chain_summary = df.groupby('Restaurant Name').agg({
'Aggregate rating': 'mean',
'Votes': 'sum'
})
chain_summary.sort_values(by=['Aggregate rating', 'Votes'], ascending=[False, False], inplace=True)
print("Top Restaurant Chains:")
print(chain_summary.head(10))
Top Restaurant Chains:
Aggregate rating Votes
Restaurant Name
Talaga Sampireun 4.9 5514
Mirchi And Mime 4.9 3244
McGuire's Irish Pub & Brewery 4.9 2238
Indian Accent - The Manor 4.9 1934
Pom Pom's Teahouse and Sandwicheria 4.9 1457
Mazzaro's Italian Market 4.9 1424
Mr. Dunderbak's Biergarten and Marketplatz 4.9 1413
Tresind - Nassima Royal Hotel 4.9 1352
Mama's Fish House 4.9 1343
Yellow Dog Eats 4.9 1252
In [ ]: